Executive summary
3

Troubles that occurred During Project
1. Pointer KPIs: Creating Upward and Downward Pointer for the KPIs took me time to find out the workaround, I had to create 2 measures one for the pointer to be up or down, the second measure was for the coloring condition, and it worked great
2. Incomplete dataset: the data set was incomplete; I had to fill up the gaps as certain accidents didn’t have data and the other complementary information required to produce an informative dashboard.
3. Dax and measure: I had to create a series of Dax measures and calculated columns to build this dashboard; lots of research helped me too in achieving this thing.

Lead more on common challenges encountered while building a dashboard in power bi and how to overcome them
https://www.knowledgehut.com/blog/business-intelligence-and-visualization/power-bi-limitations
Executive summary
3

Troubles that occurred During Project
1. Pointer KPIs: Creating Upward and Downward Pointer for the KPIs took me time to find out the workaround, I had to create 2 measures one for the pointer to be up or down, the second measure was for the coloring condition, and it worked great
2. Incomplete dataset: the data set was incomplete; I had to fill up the gaps as certain accidents didn’t have data and the other complementary information required to produce an informative dashboard.
3. Dax and measure: I had to create a series of Dax measures and calculated columns to build this dashboard; lots of research helped me too in achieving this thing.

Lead more on common challenges encountered while building a dashboard in power bi and how to overcome them
https://www.knowledgehut.com/blog/business-intelligence-and-visualization/power-bi-limitations